- HOME
- INTEGRADORES
- CHECADORES
SELECT DISTINCT(a_id) idp,a_nmb nmb, a_cb idpp,MIN(ap_precio) precio,a_sku sku,aw_departamento dpto,aw_concepto conecpto,a_categoria categoria,aw_inventariado,aw_tienda,aw_ctye,a_modelo,a_marca aw_marca
FROM articulos
INNER JOIN articulosw ON a_id = aw_id
INNER JOIN categoriasw ON a_categoria = cw_categoria
INNER JOIN articulos_precios ON a_id = ap_articulo
WHERE a_estatus = "A" AND ap_esquema = "1" AND ap_precio > 0 AND aw_tienda IN ("0","1") AND cw_id = "29"
AND ap_activo = "1"
GROUP BY a_id ORDER BY aw_visitas DESC, precio ASC LIMIT 0,24